UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5MyHF16MgY+OA4d/F8rDbM65cRD8pj8XYexKz1wYq9k='
WHERE
key_id = '5a1fc952369d2fbbacb95949aa098632dd08de11db879cf54e5772b5e130b40e'
AND (
token = '5MyHF16MgY+OA4d/F8rDbM65cRD8pj8XYexKz1wYq9k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)