UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X3UdWnUKSk6zCkOEfSxKSIQcvglU5KTYrB5CTSItPRw='
WHERE
key_id = 'a7bf5a0aeff4ba113fe799a6e8f0989c334098d6fe5c0d510386cd1bc2fbd0bb'
AND (
token = 'X3UdWnUKSk6zCkOEfSxKSIQcvglU5KTYrB5CTSItPRw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)