UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XegGZFaT5tvhuoPIBD2ZMWTgFQvoii6F8PusQSYy7MM='
WHERE
key_id = '8d1e4e8080f7b334e0c626bfaec93dc41b1ff38a54ca9f6662599d2cee2c602a'
AND (
token = 'XegGZFaT5tvhuoPIBD2ZMWTgFQvoii6F8PusQSYy7MM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)