UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cT1ciYjTDFTUY6xUam0h+GXVrzYQYU77c0BHjtd6J0U='
WHERE
key_id = 'f19b3e8039ece939d5d5c9abb43db5abace60827cf70a92f9db7968c7f6f93a2'
AND (
token = 'cT1ciYjTDFTUY6xUam0h+GXVrzYQYU77c0BHjtd6J0U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)