UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1ZHWr746G0qddDL0iOnCxabBwpF2IjZMPPheeYeXPy4='
WHERE
key_id = '5d2ca16e561653c4162b3d1c72f1fe360c3b196965fc14af2a6daae57a9390d0'
AND (
token = '1ZHWr746G0qddDL0iOnCxabBwpF2IjZMPPheeYeXPy4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)