UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sN99S9Li776429v6CexERSKa5GWtZqUJMvcd0A5AyoI='
WHERE
key_id = 'ccfdfeab613cca39b75b55d59f955948d4b2db54f91ed7aa73e1c09d81e647b8'
AND (
token = 'sN99S9Li776429v6CexERSKa5GWtZqUJMvcd0A5AyoI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)