UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B79724gLPf3L8nieo3Rjy3eErjataGZEzgWWGb2R3ck='
WHERE
key_id = '48ecfccf170bcc6b33861a68fd07c481d563a519b51549c00133a4e636599ba1'
AND (
token = 'B79724gLPf3L8nieo3Rjy3eErjataGZEzgWWGb2R3ck='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)