UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NmRR7M5qOfWK3ZnHrAqSF12JLz5K/WcvMlrDds5f3c8='
WHERE
key_id = '8af2ff3cca9abf765b9c17d82cad25838653b55abd7b9376529031a22dc224f0'
AND (
token = 'NmRR7M5qOfWK3ZnHrAqSF12JLz5K/WcvMlrDds5f3c8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)