UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4eEig03rQSjXlkimINLk8ZreFqHdHaFwUC9ydOkilv8='
WHERE
key_id = 'efc0688451db527055370622e3fdc2162e3aa96f579924e6f4e0cdc16b34e1e7'
AND (
token = '4eEig03rQSjXlkimINLk8ZreFqHdHaFwUC9ydOkilv8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)