UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zNUzyJNJKkgCw0fC8FKMX/IaeunC0jp8NXPwmOPYGC8='
WHERE
key_id = 'd07e4e23defe0293be60adb59d20546d8e3a9657c642f45bd1feaf36eacbcead'
AND (
token = 'zNUzyJNJKkgCw0fC8FKMX/IaeunC0jp8NXPwmOPYGC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)