UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oCiuRPFTas3QFd0TK5XjH/th7KM+xEWOArfMQEKkhCc='
WHERE
key_id = 'a446f09ea997982281b14f8fda271c9e366ca351b34f1b30bd2a65bb931c644a'
AND (
token = 'oCiuRPFTas3QFd0TK5XjH/th7KM+xEWOArfMQEKkhCc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)