UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P3ZOpBaf9GXf000Lb9GJ2FTuXPP4M5pNzo/mpAi08+k='
WHERE
key_id = 'ed574020d1aa1d43d753e1777154964da48f9cb1695cef43de5b861a5c64a3e5'
AND (
token = 'P3ZOpBaf9GXf000Lb9GJ2FTuXPP4M5pNzo/mpAi08+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)