UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'zEUXFMfG81/nfsMXFRvl776NBbaHDm1X+A74FZ9VfJA=' 
WHERE 
  key_id = '6ae0aa5d58e67a6dbc47131f251826594afde85a86dd3cb1496f533fb31e8815' 
  AND (
    token = 'zEUXFMfG81/nfsMXFRvl776NBbaHDm1X+A74FZ9VfJA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024