UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JemITLHmofaJiQYs+qGHpIKywPpaIidOqRprEc4Njwk='
WHERE
key_id = 'a51507f8c385e0d13c1377c6e28edbf5153fffd75d42f1761de734e1c4fc44ea'
AND (
token = 'JemITLHmofaJiQYs+qGHpIKywPpaIidOqRprEc4Njwk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)