UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zk4kzF0Ga7YCVU43tdZNcOWh5ZnoTKfXpmpyIF9j1k8='
WHERE
key_id = '230b61b8862579e8448354bb84db06c462289dd9caddba055f3ef589ebb07600'
AND (
token = 'Zk4kzF0Ga7YCVU43tdZNcOWh5ZnoTKfXpmpyIF9j1k8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)