UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'acxNK7D7ox5OfzXGqwQ3QYn0poWuRgTlglwENdx9N8s='
WHERE
key_id = '3acdde0f388e9471b031dacc06b9751a68b8dc24075a75faa7ebbdceab7a8ab3'
AND (
token = 'acxNK7D7ox5OfzXGqwQ3QYn0poWuRgTlglwENdx9N8s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)