UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nN/dsGEX1+ACa/u7N+IqbqhjLlomD4o0TtzArat7Jgk='
WHERE
key_id = '4d2794486755608b820d360ccad5cf2c445da68b082b97e7bb7ac62d3e099561'
AND (
token = 'nN/dsGEX1+ACa/u7N+IqbqhjLlomD4o0TtzArat7Jgk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)