UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W6/3w9KyA+ryKPgBsa71d+ChEHcvWK1ECDczDaTldJE='
WHERE
key_id = 'd1e0b68d4dc528a00069bc97744fd33a7312a4aa1af12da426483ea8539dec92'
AND (
token = 'W6/3w9KyA+ryKPgBsa71d+ChEHcvWK1ECDczDaTldJE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)