UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HOZtoJD9q2hcEPdOYBNB6H6I/yDJLeSzh/wREkeTIdY='
WHERE
key_id = '8ef434dfe7e9a04ee1d4fec6d85bd1450a9a5b0354a3df1b27fab0842e8d127e'
AND (
token = 'HOZtoJD9q2hcEPdOYBNB6H6I/yDJLeSzh/wREkeTIdY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)