UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fmYg/3/6pdzMQ2K5pnl9lWl9cBVB8PGjkyv44l10ttA='
WHERE
key_id = 'f814026753d02c27034039f4d32c10def0d1c05ccfb5dfd1c8f95bd487ef01c9'
AND (
token = 'fmYg/3/6pdzMQ2K5pnl9lWl9cBVB8PGjkyv44l10ttA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)