UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UE+QR6iKJiTqzP1Crp+/Q4GE3TfEl5/e1ZGM2sLzxZ8='
WHERE
key_id = '565d6c0e7ef8466336e0723049505457025edd8ede7a978e6bb87456ddba51bc'
AND (
token = 'UE+QR6iKJiTqzP1Crp+/Q4GE3TfEl5/e1ZGM2sLzxZ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)