UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'slAlvZiZ+eJnKFyrrKhERJZfxCFOkCH9P/LltNSu1jU='
WHERE
key_id = '38b8534989587f0ca81251fcdc434949070b925021a5103e1133329d23ba1a2e'
AND (
token = 'slAlvZiZ+eJnKFyrrKhERJZfxCFOkCH9P/LltNSu1jU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)