UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/tgiR1+A1LQN34Wrsh2bKZKQX7/rtNnnNjQz5LR8KL8='
WHERE
key_id = '9835508073c24daa637e4ce41f30a9c526d8f6aed4bda216e100b366340e084e'
AND (
token = '/tgiR1+A1LQN34Wrsh2bKZKQX7/rtNnnNjQz5LR8KL8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)