UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dRTzOwH+mIO1D1aoySsbg01Vss/Gl9o+EUutIOfxK3k='
WHERE
key_id = 'fabe4a87fb83bc3531afef5a94158e8da871e87450e50f82ff42b087a0377832'
AND (
token = 'dRTzOwH+mIO1D1aoySsbg01Vss/Gl9o+EUutIOfxK3k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)