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