UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zJmEaD30npMcdnZUDGKXjnboR6+7b1ga+7MYo8dL2rY='
WHERE
key_id = 'a7c3f4c1ef7e7894fbea085715d8df6ab517e1a131ed767fd112cedd9dcfe11e'
AND (
token = 'zJmEaD30npMcdnZUDGKXjnboR6+7b1ga+7MYo8dL2rY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)