UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QCfIbWkL7vSj82PAuRelecA0G58X9sICCzqQ/vTYPo8='
WHERE
key_id = 'cc8fde3cc389a79f821a64d8b0ec5afce676211c8c2f816e95fedd753456ecef'
AND (
token = 'QCfIbWkL7vSj82PAuRelecA0G58X9sICCzqQ/vTYPo8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)