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