UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4ZNnLK294W46kJwkNK6nf8j8CbqP+Q8mHzMKrHfqOIg='
WHERE
key_id = 'e752cf8c6bf234564ef11d69be30c806105f7c893c065a19d854eb2213f9ff50'
AND (
token = '4ZNnLK294W46kJwkNK6nf8j8CbqP+Q8mHzMKrHfqOIg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)