UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZZlpUY+3uNkLPYkMC4r+pMZdKTJjACFLC39zRaO3sNw='
WHERE
key_id = 'e7bec83b5d4dd2e652ab6d121b70a7e56296cac72b31874dc5f667c126068b77'
AND (
token = 'ZZlpUY+3uNkLPYkMC4r+pMZdKTJjACFLC39zRaO3sNw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)