UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nrEgVVOxrutqBZIDHQ7d8+ERcBDrOOM6s87eHV2uQc0='
WHERE
key_id = 'b8965a72447ed3ec46d30867131be222e20626d0d14c5a6457fbe53952e56070'
AND (
token = 'nrEgVVOxrutqBZIDHQ7d8+ERcBDrOOM6s87eHV2uQc0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)